﻿
CREATE TRIGGER [tr_Borrower_InstantID]
ON [dbo].[t_Borrower] 
FOR UPDATE
AS
IF UPDATE(LastName) OR UPDATE(FirstName) OR
	 UPDATE(SSN) OR UPDATE(DriverLicense) OR
	 UPDATE(DOBMonth) OR UPDATE(DOBDay) OR UPDATE(DOBYear) BEGIN
	UPDATE t_Borrower SET InstantIDHTML = NULL, InstantIDScore = NULL,DriverLicenseHTML = NULL WHERE ID IN (SELECT ID FROM inserted)
END


